﻿/********************************************************************************************************************
* Author:	Aris Michail																							*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getdisabledusers" that returns all 	*
*			disabled users.																							*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getDisabledUsers]
AS
	SELECT username
	FROM Users
	WHERE users.IsEnabled = 0
RETURN 0